<?php
require("inc/conn637.php");
$result=mysql_query("select * from lyb",$conn);
?>
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>无标题文档</title>
</head>

<body>
	<p><a href="lyb_insert637.php" title="添加留言" target="blank">添加留言</a> &nbsp;&nbsp;<a href="lyb_delall637.php" title="批量删除" target="_blank">批量删除</a></p>	
	<table width="90%" border="1" alalign="center">
  <tbody>
    <tr>
      <td>&nbsp;留言编号</td>
      <td>&nbsp;留言标题</td>
      <td>&nbsp;内容</td>
      <td>&nbsp;作者</td>
      <td>&nbsp;性别</td>
      <td>&nbsp;电子邮箱</td>
      <td>&nbsp;发布日期</td>
      <td>&nbsp;IP</td>
      <td>&nbsp;编辑</td>
    </tr>
   <?php while ($row=mysql_fetch_assoc($result)){//循环开始?>
    <tr>
     <td><?= $row["ID"]?></td>
     <td width="120"><?= $row["title"]?></td>
     <td width="200"><?= $row["content"]?></td>
     <td><?= $row["author"]?></td>
     <td><?= $row["sex"]?></td>
     <td><?= $row["Email"]?></td>
     <td width="180"><?= $row["addtime"]?></td>
     <td><?= $row["IP"]?></td>
     <td width="120" align="center"><a href="lyb_update637.php?id=<?= $row['ID']?>">更新</a>&nbsp;&nbsp;<a onClick="return confirm('您确定要删除吗？')" href="lyb_delete637.php?id=<?= $row['ID']?>">删除 </a> </td>
    </tr>
<?php
  }//循环结束
?>
<p>记录总数：<?php echo mysql_num_rows($result);
mysql_free_result($result);
mysql_close($conn);
?>
  </tbody>
</table>
</body>
</html>